﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 工作日志实体类：workLog 。
	/// </summary>
	[Serializable]
	public class workLog
	{
		public workLog()
		{}

		#region Model
		private int _id; //id
		private string _cata; //分类
		private DateTime? _dt; //日期
		private string _plan; //计划
		private string _log; //日志
		private string _comment; //评语


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 分类
		/// </summary>
		public string cata
		{
			set{ _cata=value;}
			get{return _cata;}
		}
        /// <summary>
		/// 日期
		/// </summary>
		public DateTime? dt
		{
			set{ _dt=value;}
			get{return _dt;}
		}
        /// <summary>
		/// 计划
		/// </summary>
		public string plan
		{
			set{ _plan=value;}
			get{return _plan;}
		}
        /// <summary>
		/// 日志
		/// </summary>
		public string log
		{
			set{ _log=value;}
			get{return _log;}
		}
        /// <summary>
		/// 评语
		/// </summary>
		public string comment
		{
			set{ _comment=value;}
			get{return _comment;}
		}
		#endregion Model

		#region txt document
		/*
工作日志,workLog
id,分类,日期,计划,日志,评语
id,cata,dt,plan,log,comment
i,c10,d,c1000,c1000,c1000

--------------------------
-- 创建表[工作日志]开始: 
-- alter table  [BZZ_workLog] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_workLog') drop table BZZ_workLog
  CREATE TABLE [BZZ_workLog] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [cata] [varchar] (10),
	 [dt] [datetime],
	 [plan] [varchar] (1000),
	 [log] [varchar] (1000),
	 [comment] [varchar] (1000)
  )

 exec sp_addextendedproperty N'MS_Description',N'工作日志 ',N'user',N'dbo',N'table',N'BZZ_workLog', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_workLog',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'分类',N'user',N'dbo',N'table',N'BZZ_workLog',N'column',N'cata'
 exec sp_addextendedproperty N'MS_Description',N'日期',N'user',N'dbo',N'table',N'BZZ_workLog',N'column',N'dt'
 exec sp_addextendedproperty N'MS_Description',N'计划',N'user',N'dbo',N'table',N'BZZ_workLog',N'column',N'plan'
 exec sp_addextendedproperty N'MS_Description',N'日志',N'user',N'dbo',N'table',N'BZZ_workLog',N'column',N'log'
 exec sp_addextendedproperty N'MS_Description',N'评语',N'user',N'dbo',N'table',N'BZZ_workLog',N'column',N'comment'

-- 创建表[工作日志]结束。 
--------------------------

		*/
		#endregion document
	}
}

